<?php
	include('include/configs.inc.php');
	
	$sql1 = "SELECT alb.debut_location, alb.fin_location, b.adresse, b.pays FROM archive_location_bien alb INNER JOIN bien b ON b.id=alb.id_bien WHERE id_locataire=".$_SESSION['UID'];
	$sql2 = "SELECT lb.debut_location, lb.fin_location, b.adresse, b.pays FROM location_bien lb INNER JOIN bien b ON b.id=lb.id_bien WHERE id_locataire=".$_SESSION['UID'];
	
	$archives = $connect->query($sql1);
	$locations = $connect->query($sql2);
	
	$sql3 = "SELECT id FROM bien WHERE id_proprio=".$_SESSION['UID'];
	$biens = $connect->query($sql3)->num_rows;
	
	include('template/Site_connecte.html');
?>